package com.example.guiguihomemedical.mapper;

import com.example.guiguihomemedical.entity.Servicesigning;
import com.example.guiguihomemedical.entity.Userclassification;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface UserclassificationMapper {
    @Delete("delete from userclassification where idcard=#{idcard} and peopleid=#{peopleid}")
    void delete(String idcard, Integer peopleid);

    @Insert("insert into userclassification(idcard, peopleid) values(#{idcard},#{peopleid})")
    void add(Userclassification userclassification);

    @Select("select * from userclassification where idcard=#{idcard}")
    List<Userclassification> geyByIdcard(String idcard);
@Select("select * from userclassification")
    List<Userclassification> getAll();
}
